Item Master (IV00101)

azurecurve Products Microsoft Dynamics GP (0)InventoryItem Master (IV00101)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV00101

Product: Microsoft Dynamics GP (0)
Series: Inventory

Display Name: Item Master
Physical Name: IV00101
Technical Name: IV_Item_MSTR

Group Display Name: Item Master
Group Technical Name: Item Master

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ITEMNMBR	Item Number	String	STR30_Item_Number	30
2	ITEMDESC	Item Description	String	STR100	100
3	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Item Master'].NOTEINDX AS 'Item Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM IV00101 AS ['Item Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Item Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
4	ITMSHNAM	Item Short Name	String	STR15	15
5	ITEMTYPE	Item Type	Integer	DDL_Item_Type	0
6	ITMGEDSC	Item Generic Description	String	STR10	10
7	STNDCOST	Standard Cost	Currency	DLR17_RBS0_UTR$	17
8	CURRCOST	Current Cost	Currency	DLR17_RBS0_UTR$	17
9	ITEMSHWT	Item Shipping Weight	Long Integer	LI6_RBS2_UT	6
10	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
11	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
12	ITMTSHID	Item Tax Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Item Master'].ITMTSHID AS 'Item Master-Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM IV00101 AS ['Item Master'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Item Master'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
13	TAXOPTNS	Tax Options	Integer	DDL_Tax_Options	0
14	IVIVINDX	IV IV Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVIVINDX AS 'Item Master-IV IV Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVIVINDX = ['Account Index Master'].ACTINDX
15	IVIVOFIX	IV IV Offset Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVIVOFIX AS 'Item Master-IV IV Offset Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVIVOFIX = ['Account Index Master'].ACTINDX
16	IVCOGSIX	IV COGS Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVCOGSIX AS 'Item Master-IV COGS Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVCOGSIX = ['Account Index Master'].ACTINDX
17	IVSLSIDX	IV Sales Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVSLSIDX AS 'Item Master-IV Sales Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVSLSIDX = ['Account Index Master'].ACTINDX
18	IVSLDSIX	IV Sales Discounts Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVSLDSIX AS 'Item Master-IV Sales Discounts Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVSLDSIX = ['Account Index Master'].ACTINDX
19	IVSLRNIX	IV Sales Returns Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVSLRNIX AS 'Item Master-IV Sales Returns Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVSLRNIX = ['Account Index Master'].ACTINDX
20	IVINUSIX	IV In Use Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVINUSIX AS 'Item Master-IV In Use Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVINUSIX = ['Account Index Master'].ACTINDX
21	IVINSVIX	IV In Service Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVINSVIX AS 'Item Master-IV In Service Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVINSVIX = ['Account Index Master'].ACTINDX
22	IVDMGIDX	IV Damaged Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVDMGIDX AS 'Item Master-IV Damaged Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVDMGIDX = ['Account Index Master'].ACTINDX
23	IVVARIDX	IV Variances Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVVARIDX AS 'Item Master-IV Variances Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVVARIDX = ['Account Index Master'].ACTINDX
24	DPSHPIDX	Drop Ship Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].DPSHPIDX AS 'Item Master-Drop Ship Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].DPSHPIDX = ['Account Index Master'].ACTINDX
25	PURPVIDX	Purchase Price Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].PURPVIDX AS 'Item Master-Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].PURPVIDX = ['Account Index Master'].ACTINDX
26	UPPVIDX	Unrealized Purchase Price Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].UPPVIDX AS 'Item Master-Unrealized Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].UPPVIDX = ['Account Index Master'].ACTINDX
27	IVRETIDX	Inventory Returns Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVRETIDX AS 'Item Master-Inventory Returns Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVRETIDX = ['Account Index Master'].ACTINDX
28	ASMVRIDX	Assembly Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].ASMVRIDX AS 'Item Master-Assembly Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].ASMVRIDX = ['Account Index Master'].ACTINDX
29	ITMCLSCD	Item Class Code	String	STR10_Class_ID	10
	Key to the Item Class Setup (IV40400). Click to show/hide SELECT ['Item Master'].ITMCLSCD AS 'Item Master-Item Class Code' ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code' FROM IV00101 AS ['Item Master'] INNER JOIN IV40400 AS ['Item Class Setup'] ON ['Item Master'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
30	ITMTRKOP	Item Tracking Option	Integer	DDL_Track	0
	Designation for the tracking type of the Item. Click to show/hide Item Tracking Options 1 0 decimals 2 1 3 2 4 3 5 4 6 5
31	LOTTYPE	Lot Type	String	STR10_Lot_Type	10
32	KPERHIST	Keep Period History	Boolean	CB_Keep_Period_History	0
33	KPTRXHST	Keep Trx History	Boolean	CB_Keep_Trx_History	0
34	KPCALHST	Keep Calendar History	Boolean	CB_Keep_Calendar_History	0
35	KPDSTHST	Keep Distribution History	Boolean	CB_Keep_Dist_History	0
36	ALWBKORD	Allow Back Orders	Boolean	CB_Allow_Back_Orders	0
37	VCTNMTHD	Valuation Method	Integer	DDL_Valuation_Method	0
	The valuation method for the inventory line item. Click to show/hide Valuation methods 1 FIFO Perpetual 2 LIFO Perpetual 3 Average Perpetual 4 FIFO Periodic 5 LIFO Periodic
38	UOMSCHDL	U Of M Schedule	String	STR10_Schedule	10
	Key to the Inventory U of M Schedule Setup (IV40201). Click to show/hide SELECT ['Item Master'].UOMSCHDL AS 'Item Master-U Of M Schedule' ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule' FROM IV00101 AS ['Item Master'] INNER JOIN IV40201 AS ['Inventory U of M Schedule Setup'] ON ['Item Master'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
39	ALTITEM1	Alternate Item 1	String	STR30_Item_Number	30
40	ALTITEM2	Alternate Item 2	String	STR30_Item_Number	30
41	USCATVLS_1	User Category Values[1]	String	User_Category_Value	10
42	USCATVLS	User Category Values	User_Category_Value	String	10
43	USCATVLS_2	User Category Values[2]	String	User_Category_Value	10
44	USCATVLS_3	User Category Values[3]	String	User_Category_Value	10
45	USCATVLS_4	User Category Values[4]	String	User_Category_Value	10
46	USCATVLS_5	User Category Values[5]	String	User_Category_Value	10
47	USCATVLS_6	User Category Values[6]	String	User_Category_Value	10
48	MSTRCDTY	Master Record Type	Integer	INT1	1
49	MODIFDT	Modified Date	Date	DT	8
50	CREATDDT	Created Date	Date	DT	8
51	WRNTYDYS	Warranty Days	Integer	INT4	4
52	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
53	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Item Master'].LOCNCODE AS 'Item Master-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM IV00101 AS ['Item Master'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Item Master'].LOCNCODE = ['Site Setup'].LOCNCODE
54	PINFLIDX	Purch Inflation Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].PINFLIDX AS 'Item Master-Purch Inflation Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].PINFLIDX = ['Account Index Master'].ACTINDX
55	PURMCIDX	Purch Monetary Correction Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].PURMCIDX AS 'Item Master-Purch Monetary Correction Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].PURMCIDX = ['Account Index Master'].ACTINDX
56	IVINFIDX	Inventory Inflation Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVINFIDX AS 'Item Master-Inventory Inflation Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVINFIDX = ['Account Index Master'].ACTINDX
57	INVMCIDX	Inventory Monetary Correction Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].INVMCIDX AS 'Item Master-Inventory Monetary Correction Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].INVMCIDX = ['Account Index Master'].ACTINDX
58	CGSINFLX	COGS Inflation Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].CGSINFLX AS 'Item Master-COGS Inflation Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].CGSINFLX = ['Account Index Master'].ACTINDX
59	CGSMCIDX	COGS Monetary Correction Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].CGSMCIDX AS 'Item Master-COGS Monetary Correction Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].CGSMCIDX = ['Account Index Master'].ACTINDX
60	ITEMCODE	Item Code	String	STR15	15
61	TCC	Tax Commodity Code	String	STR30_VAT	30
62	PriceGroup	Price Group	String	STR10_LBAU	10
63	PRICMTHD	Price Method	Integer	DDL_Price_Method	0
64	PRCHSUOM	Purchasing U Of M	String	U_Of_M	8
65	SELNGUOM	Selling U Of M	String	U_Of_M	8
66	KTACCTSR	Kit COGS Account Source	Integer	GB	0
67	LASTGENSN	Last Generated Serial Number	String	STR20_LBAU	20
68	ABCCODE	ABC Code	Integer	DDL_ABC_Code	0
69	Revalue_Inventory	Revalue Inventory	Boolean	CB_Revalue_Inventory	0
70	Tolerance_Percentage	Tolerance Percentage	Long Integer	LI7_U%3	7
71	Purchase_Item_Tax_Schedu	Purchase Item Tax Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Item Master'].Purchase_Item_Tax_Schedu AS 'Item Master-Purchase Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM IV00101 AS ['Item Master'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Item Master'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
72	Purchase_Tax_Options	Purchase Tax Options	Integer	DDL_Purchase_Tax_Options	0
73	ITMPLNNNGTYP	Item Planning Type	Integer	DDL_Item_Planning_Type	0
74	STTSTCLVLPRCNTG	Statistical Value Percentage	Integer	INT4_%2	4
75	CNTRYORGN	Country Origin	String	STR6_VAT	6
76	INACTIVE	Inactive	Boolean	CB_Inactive	0
77	MINSHELF1	MinShelfLife1	Integer	INT4_U0	4
78	MINSHELF2	MinShelfLife2	Integer	INT4_U0	4
79	INCLUDEINDP	Include in Demand Planning	Boolean	CB_IncludeInDemandPlanning	0
80	LOTEXPWARN	Lot Expire Warning	Boolean	CB_Lot_Expire_Warning	0
81	LOTEXPWARNDAYS	Lot Expire Warning Days	Integer	INT3_RB0_U	3
82	LASTGENLOT	Last Generated Lot Number	String	STR20_LBAU	20
83	Lot_Split_Quantity	Lot Split Quantity	Currency	DLR17_QTY_RBS0_UTR	17
84	UseQtyOverageTolerance	Use Qty Overage Tolerance	Boolean	CB	0
85	UseQtyShortageTolerance	Use Qty Shortage Tolerance	Boolean	CB	0
86	QtyOverTolerancePercent	Qty Overage Tolerance Percentage	Long Integer	LI5_%3	5
87	QtyShortTolerancePercent	Qty Shortage Tolerance Percentage	Long Integer	LI5_%3	5
88	IVSCRVIX	IV STD Cost Revaluation Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Item Master'].IVSCRVIX AS 'Item Master-IV STD Cost Revaluation Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM IV00101 AS ['Item Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Item Master'].IVSCRVIX = ['Account Index Master'].ACTINDX
89	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Item Master'].USERID AS 'Item Master-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM IV00101 AS ['Item Master'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Item Master'].USERID = ['Users Master'].USERID

azurecurve Products Microsoft Dynamics GP (0)InventoryItem Master (IV00101)

2 thoughts on “Item Master (IV00101)”

Hussain Al Yousef says:

23rd June 2022 at 0701

ITEMTYPE = Item Types:
1 – Sales Inventory
2 – Discontinued
3 – Kit
4 – Misc Charges
5 – Services
6 – Flat Fee

1. iangrieve says:
  
  23rd June 2022 at 0803
  
  Thanks for contributing this.

2 thoughts on “Item Master (IV00101)”

Leave a Reply Cancel reply